Schillers DPG

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent46c5404893f7d8e229da7750c4799343
  time1765004353
  countdown10
- UserAuth(empty)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerbrands
- actionshop_categories_by_brand
- named(empty)
- pass(array)
  0Roland DGA
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Logs

default

Total Time: 424 ms
Total Queries: 362 queries

Query	Affected	Num. rows	Took (ms)
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1189 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1189 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1541 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1541 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 742 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1544 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1544 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 861 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 861 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 9	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 107	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1549 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1549 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1551 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1551 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	3	3	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 46	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 46	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1552 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1552 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 46	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1553 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1553 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	3	3	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 89	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 159	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1550 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1550 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 52	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 219 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 744 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 213 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1555 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1555 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 51	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1557 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1557 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1558 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1558 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 918 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 918 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 994 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 994 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1561 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1561 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	3	3	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1563 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1563 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 935 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 935 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1562 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1562 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	3	3	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1567 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1567 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1419 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1419 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 808 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1400 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1400 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1391 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1391 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1402 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1402 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1554 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1554 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	6	6	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 18	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 31	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 8	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 180	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1569 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1569 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1574 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1574 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 815 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1559 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1559 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	1
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1577 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1577 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1579 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1579 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 12	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 40	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1582 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1582 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 12	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 40	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 936 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 936 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1589 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1589 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1592 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1592 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1597 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1597 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1602 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1601 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1601 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1605 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1605 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1565 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1565 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1492 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1610 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1610 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1612 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1612 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1611 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1611 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1296 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1296 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1490 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1491 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1537 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1489 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1489 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1608 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1608 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 11	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 19	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1613 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1613 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1598 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1598 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1091 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 811 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1092 AND `Product`.`publish_flag` = 'Y' LIMIT 1	0	0	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1576 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1576 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1578 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1578 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	2	2	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 10	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 1615 AND `Product`.`publish_flag` = 'Y' LIMIT 1	1	1	0
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`categories` AS `Category` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 1615 AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` IS NOT NULL	1	1	0
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`template_id`, `ParentCategory`.`slug`, `ParentCategory`.`slug_lock`, `ParentCategory`.`publish_flag`, `ParentCategory`.`heading`, `ParentCategory`.`meta_tag_title`, `ParentCategory`.`meta_tag_description`, `ParentCategory`.`product_id`, `ParentCategory`.`seq`, `ParentCategory`.`modified` FROM `dpg_ecommerce`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 79	1	1	0
SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1	20	20	0

72 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 24.09 MB

Message	Memory use
Component initialization	4.27 MB
Controller action start	16.86 MB
Controller render start	18.67 MB
View render complete	20.73 MB

Timers

Total Request Time: 796 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	22.08
Event: Controller.initialize	481.78
Event: Controller.startup	0.50
Controller action	134.02
Event: Controller.beforeRender	9.63
» Processing toolbar data	8.46
Rendering View	29.83
» Event: View.beforeRender	0.03
» Rendering APP/View/Elements/Templates/Brands/shop_categories_by_brand.ctp	24.19
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	4.79
» » Rendering APP/View/Elements/header_menu.ctp	0.26
» » Rendering APP/View/Elements/Pages/default_page.ctp	3.04
» » » Rendering APP/View/Elements/hMenu01.ctp	2.39
» » » » Rendering APP/View/Elements/Search/productSearch.ctp	0.44
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message.ctp	0.11
» » » Rendering APP/Plugin/Usermgmt/View/Elements/message_validation.ctp	0.08
» » Rendering APP/View/Elements/dpg-footer.ctp	0.08
» » Rendering APP/View/Elements/final-footer.ctp	0.08
Event: View.afterLayout	0.00

====

Log
+

Logs

debug

Time Message
2025-12-05 20:59:13 Data AppController:

2025-12-05 20:59:13 layout_default default.ctp:

2025-12-05 20:59:13 Data default_page:

====
Variables
+
View Variables
- stockFilter*
- inkFilters(empty)
- show_debug(null)
- show_non_published(null)
- isAdmin(null)
- isAdminSub(null)
- inkTypes(array)
  Eco-SolventEco-Solvent
  SolventSolvent
  UVUV
  LatexLatex
  DyeDye
  Dye-SubDye-Sub
  PigmentPigment
  ScreenScreen
  Thermal TransferThermal Transfer
  HP Latex CertifiedHP Latex Certified
  N/AN/A
  Toner FuserToner Fuser
  Direct to Film Direct to Film
  PageWidePageWide
  Canon UVgel 356Canon UVgel 356
  OfsettOfsett
  ResinResin
  Noritsu Dry LabNoritsu Dry Lab
  Fuji Dry Lab Fuji Dry Lab
  Epson Dry Lab Epson Dry Lab
- var(empty)
- categories(array)
  0(array)
  idALL
  parent_id0
  name
  headingAll Products
  lft0
  rght0
  primary_brand_id2
  brand_nameRoland DGA
  slugALL
  parent_name
  display_nameAll Products
  allY
  masterN
  sub_masterN
  1(array)
  id15
  parent_id8
  nameBacklit
  heading
  lft2
  rght7
  primary_brand_id2
  brand_nameRoland DGA
  slugBacklit-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Backlit
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  2(array)
  id16
  parent_id15
  nameFilm
  heading
  lft3
  rght4
  primary_brand_id2
  brand_nameRoland DGA
  slugBacklit-Film-Digital-Print-Media
  parent_nameBacklit
  display_nameBacklit Film
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id15
  parent_id8
  lft2
  rght7
  nameBacklit
  template_id22
  slugBacklit-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleBacklit Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq1
  modified2023-05-03
  3(array)
  id18
  parent_id8
  nameBanner
  headingddddd
  lft8
  rght21
  primary_brand_id2
  brand_nameRoland DGA
  slugBanner-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameddddd
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  4(array)
  id23
  parent_id18
  name1-Sided
  heading(null)
  lft9
  rght10
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Banner-1-Sided
  parent_nameBanner
  display_nameBanner 1-Sided
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id18
  parent_id8
  lft8
  rght21
  nameBanner
  template_id22
  slugBanner-Digital-Print-Media
  slug_lockY
  publish_flagY
  headingddddd
  meta_tag_title
  meta_tag_description
  product_id0
  seq4
  modified2023-05-03
  5(array)
  id70
  parent_id18
  nameRollUp
  heading(null)
  lft15
  rght16
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Banner-RollUp
  parent_nameBanner
  display_nameBanner RollUp
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id18
  parent_id8
  lft8
  rght21
  nameBanner
  template_id22
  slugBanner-Digital-Print-Media
  slug_lockY
  publish_flagY
  headingddddd
  meta_tag_title
  meta_tag_description
  product_id0
  seq4
  modified2023-05-03
  6(array)
  id28
  parent_id8
  nameCanvas
  heading
  lft24
  rght25
  primary_brand_id2
  brand_nameRoland DGA
  slugCanvas-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Canvas
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  7(array)
  id31
  parent_id8
  nameFabric
  heading(null)
  lft32
  rght37
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Fabric
  parent_nameDigital Print Media
  display_nameDigital Print Media Fabric
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  8(array)
  id60
  parent_id31
  namePrintable
  heading(null)
  lft33
  rght34
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Fabric-Printable
  parent_nameFabric
  display_nameFabric Printable
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id31
  parent_id8
  lft32
  rght37
  nameFabric
  template_id22
  slugDigital-Print-Media-Fabric
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_title(null)
  meta_tag_description(null)
  product_id(null)
  seq16
  modified2023-05-03
  9(array)
  id32
  parent_id8
  nameFine Art
  heading
  lft38
  rght39
  primary_brand_id2
  brand_nameRoland DGA
  slugFine-Art-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Fine Art
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  10(array)
  id35
  parent_id8
  namePhotobase
  heading
  lft44
  rght53
  primary_brand_id2
  brand_nameRoland DGA
  slugPhotobase-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Photobase
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  11(array)
  id36
  parent_id35
  nameAdhesive Backed
  heading(null)
  lft47
  rght48
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Photobase-Adhesive-Backed
  parent_namePhotobase
  display_namePhotobase Adhesive Backed
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id35
  parent_id8
  lft44
  rght53
  namePhotobase
  template_id22
  slugPhotobase-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titlePhotobase Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq22
  modified2023-05-03
  12(array)
  id37
  parent_id35
  namePaper
  heading(null)
  lft49
  rght50
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Photobase-Paper
  parent_namePhotobase
  display_namePhotobase Paper
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id35
  parent_id8
  lft44
  rght53
  namePhotobase
  template_id22
  slugPhotobase-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titlePhotobase Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq22
  modified2023-05-03
  13(array)
  id46
  parent_id8
  nameVinyl Calendered
  heading
  lft54
  rght75
  primary_brand_id2
  brand_nameRoland DGA
  slugCalendered-Vinyl-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Vinyl Calendered
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  14(array)
  id47
  parent_id46
  nameClear
  heading(null)
  lft55
  rght56
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Vinyl-Calendered-Clear
  parent_nameVinyl Calendered
  display_nameVinyl Calendered Clear
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id46
  parent_id8
  lft54
  rght75
  nameVinyl Calendered
  template_id22
  slugCalendered-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCalendered Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq26
  modified2023-05-03
  15(array)
  id49
  parent_id46
  nameWhite
  heading(null)
  lft59
  rght60
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Vinyl-Calendered-White
  parent_nameVinyl Calendered
  display_nameVinyl Calendered White
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id46
  parent_id8
  lft54
  rght75
  nameVinyl Calendered
  template_id22
  slugCalendered-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCalendered Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq26
  modified2023-05-03
  16(array)
  id62
  parent_id46
  nameReflective
  heading(null)
  lft61
  rght62
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Vinyl-Calendered-Reflective
  parent_nameVinyl Calendered
  display_nameVinyl Calendered Reflective
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id46
  parent_id8
  lft54
  rght75
  nameVinyl Calendered
  template_id22
  slugCalendered-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCalendered Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq26
  modified2023-05-03
  17(array)
  id134
  parent_id46
  namePromotional 3-Year
  heading
  lft67
  rght68
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Vinyl-Calendered-Promotional
  parent_nameVinyl Calendered
  display_nameVinyl Calendered Promotional 3-Year
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id46
  parent_id8
  lft54
  rght75
  nameVinyl Calendered
  template_id22
  slugCalendered-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCalendered Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq26
  modified2023-05-03
  18(array)
  id191
  parent_id46
  nameIntermediate 5-Year
  heading
  lft69
  rght70
  primary_brand_id2
  brand_nameRoland DGA
  slugIntermediate-Vinyl-Calendered-Digital-Print-Media
  parent_nameVinyl Calendered
  display_nameVinyl Calendered Intermediate 5-Year
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id46
  parent_id8
  lft54
  rght75
  nameVinyl Calendered
  template_id22
  slugCalendered-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCalendered Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq26
  modified2023-05-03
  19(array)
  id195
  parent_id46
  nameIntermediate 5-Year Air Release
  heading
  lft73
  rght74
  primary_brand_id2
  brand_nameRoland DGA
  slugIntermediate-5-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media
  parent_nameVinyl Calendered
  display_nameVinyl Calendered Intermediate 5-Year Air Release
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id46
  parent_id8
  lft54
  rght75
  nameVinyl Calendered
  template_id22
  slugCalendered-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCalendered Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq26
  modified2023-05-03
  20(array)
  id51
  parent_id8
  nameWall
  heading
  lft76
  rght83
  primary_brand_id2
  brand_nameRoland DGA
  slugWall-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Wall
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  21(array)
  id53
  parent_id51
  namePSA
  heading(null)
  lft77
  rght78
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Wall-PSA
  parent_nameWall
  display_nameWall PSA
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id51
  parent_id8
  lft76
  rght83
  nameWall
  template_id22
  slugWall-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleWall Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq37
  modified2023-05-03
  22(array)
  id55
  parent_id51
  nameWallpaper
  heading(null)
  lft81
  rght82
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Wall-Wallpaper
  parent_nameWall
  display_nameWall Wallpaper
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id51
  parent_id8
  lft76
  rght83
  nameWall
  template_id22
  slugWall-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleWall Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq37
  modified2023-05-03
  23(array)
  id52
  parent_id8
  nameWindows
  heading
  lft84
  rght107
  primary_brand_id2
  brand_nameRoland DGA
  slugWindows-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Windows
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  24(array)
  id56
  parent_id52
  nameCling
  heading(null)
  lft85
  rght86
  primary_brand_id2
  brand_nameRoland DGA
  slugDigital-Print-Media-Windows-Cling
  parent_nameWindows
  display_nameWindows Cling
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id52
  parent_id8
  lft84
  rght107
  nameWindows
  template_id22
  slugWindows-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleWindows Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq41
  modified2023-05-03
  25(array)
  id59
  parent_id52
  namePrintable Etched
  heading
  lft105
  rght106
  primary_brand_id2
  brand_nameRoland DGA
  slugPrintable-Etched-Windows-Digital-Print-Media
  parent_nameWindows
  display_nameWindows Printable Etched
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id52
  parent_id8
  lft84
  rght107
  nameWindows
  template_id22
  slugWindows-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleWindows Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq41
  modified2023-05-03
  26(array)
  id64
  parent_id8
  nameVinyl Cast
  heading
  lft108
  rght119
  primary_brand_id2
  brand_nameRoland DGA
  slugCast-Vinyl-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Vinyl Cast
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  27(array)
  id186
  parent_id64
  nameReflective
  heading
  lft117
  rght118
  primary_brand_id2
  brand_nameRoland DGA
  slugReflective-Vinyl-Cast-Digital-Print-Media
  parent_nameVinyl Cast
  display_nameVinyl Cast Reflective
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id64
  parent_id8
  lft108
  rght119
  nameVinyl Cast
  template_id22
  slugCast-Vinyl-Digital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleCast Vinyl Digital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id(null)
  seq53
  modified2023-05-03
  28(array)
  id71
  parent_id8
  nameRollUp
  heading
  lft122
  rght123
  primary_brand_id2
  brand_nameRoland DGA
  slugRollUp-Banner-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media RollUp
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  29(array)
  id89
  parent_id8
  nameHeat Transfer
  heading
  lft124
  rght131
  primary_brand_id2
  brand_nameRoland DGA
  slugHeat-Transfer-Digital-Print-Media
  parent_nameDigital Print Media
  display_nameDigital Print Media Heat Transfer
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id8
  parent_id(null)
  lft1
  rght140
  nameDigital Print Media
  template_id2799
  slugDigital-Print-Media
  slug_lockY
  publish_flagY
  heading
  meta_tag_titleDigital Print Media | Schiller's Digital Printer Group
  meta_tag_description
  product_id0
  seq0
  modified2024-01-03
  30(array)
  id90
  parent_id89
  namePrint/Cut Films
  heading
  lft125
  rght126
  primary_brand_id2
  brand_nameRoland DGA
  slugPrint-Cut-Films-Heat-Transfer-Digital-Print-Media
  parent_nameHeat Transfer
  display_nameHeat Transfer Print/Cut Films
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id89
  parent_id8
  lft124
  rght131
  nameHeat Transfer
  template_id22
  slugHeat-Transfer-Digital-Print-Media
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq61
  modified2023-05-03
  31(array)
  id157
  parent_id89
  nameTransfer Mask
  heading
  lft129
  rght130
  primary_brand_id2
  brand_nameRoland DGA
  slugTransfer-Mask-Heat-Transfer-Digital-Print-Media
  parent_nameHeat Transfer
  display_nameHeat Transfer Transfer Mask
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id89
  parent_id8
  lft124
  rght131
  nameHeat Transfer
  template_id22
  slugHeat-Transfer-Digital-Print-Media
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq61
  modified2023-05-03
  32(array)
  id107
  parent_id9
  nameVinyl Cutter Blades
  heading(null)
  lft144
  rght147
  primary_brand_id2
  brand_nameRoland DGA
  slugGraphic-Sign-Vinyl-Cutter-Blades
  parent_nameGraphic/Sign
  display_nameGraphic/Sign Vinyl Cutter Blades
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id9
  parent_id(null)
  lft143
  rght152
  nameGraphic/Sign
  template_id22
  slugGraphic-Sign
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_title(null)
  meta_tag_description(null)
  product_id(null)
  seq69
  modified2023-05-03
  33(array)
  id128
  parent_id107
  nameRoland
  heading(null)
  lft145
  rght146
  primary_brand_id2
  brand_nameRoland DGA
  slugGraphic-Sign-Vinyl-Cutter-Blades-Roland
  parent_nameVinyl Cutter Blades
  display_nameVinyl Cutter Blades Roland
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id107
  parent_id9
  lft144
  rght147
  nameVinyl Cutter Blades
  template_id22
  slugGraphic-Sign-Vinyl-Cutter-Blades
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_title(null)
  meta_tag_description(null)
  product_id(null)
  seq70
  modified2023-05-03
  34(array)
  id79
  parent_id10
  nameRoland
  heading(null)
  lft154
  rght175
  primary_brand_id2
  brand_nameRoland DGA
  slugHardware-Roland
  parent_nameHardware
  display_nameHardware Roland
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id10
  parent_id(null)
  lft153
  rght208
  nameHardware
  template_id23
  slugHardware
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq74
  modified2023-05-03
  35(array)
  id239
  parent_id79
  nameResin
  heading
  lft155
  rght156
  primary_brand_id2
  brand_nameRoland DGA
  slugResin-Roland
  parent_nameRoland
  display_nameRoland Resin
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  36(array)
  id102
  parent_id79
  namePrint Only
  heading(null)
  lft157
  rght158
  primary_brand_id2
  brand_nameRoland DGA
  slugHardware-Roland-Print-Only
  parent_nameRoland
  display_nameRoland Print Only
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  37(array)
  id103
  parent_id79
  namePrinter/Cutters
  heading(null)
  lft159
  rght160
  primary_brand_id2
  brand_nameRoland DGA
  slugHardware-Roland-Printer-Cutters
  parent_nameRoland
  display_nameRoland Printer/Cutters
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  38(array)
  id108
  parent_id79
  nameUV Benchtop Flatbed
  heading
  lft161
  rght162
  primary_brand_id2
  brand_nameRoland DGA
  slugUV-Benchtop-Flatbed-Roland-Hardware
  parent_nameRoland
  display_nameRoland UV Benchtop Flatbed
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  39(array)
  id109
  parent_id79
  nameUV Printer/Cutters
  heading(null)
  lft163
  rght164
  primary_brand_id2
  brand_nameRoland DGA
  slugHardware-Roland-UV-Printer-Cutters
  parent_nameRoland
  display_nameRoland UV Printer/Cutters
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  40(array)
  id116
  parent_id79
  nameVinyl Cutters
  heading(null)
  lft165
  rght166
  primary_brand_id2
  brand_nameRoland DGA
  slugHardware-Roland-Vinyl-Cutters
  parent_nameRoland
  display_nameRoland Vinyl Cutters
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  41(array)
  id141
  parent_id79
  nameReplacement Parts
  heading(null)
  lft169
  rght170
  primary_brand_id2
  brand_nameRoland DGA
  slugHardware-Roland-Common-Replacement-Parts
  parent_nameRoland
  display_nameRoland Replacement Parts
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  42(array)
  id225
  parent_id79
  nameUV Flatbed
  heading
  lft171
  rght172
  primary_brand_id2
  brand_nameRoland DGA
  slugUV-Flatbed-Roland-Hardware
  parent_nameRoland
  display_nameRoland UV Flatbed
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  43(array)
  id226
  parent_id79
  nameDirect-to-Garment Printer
  heading
  lft173
  rght174
  primary_brand_id2
  brand_nameRoland DGA
  slugDirect-to-Garment-Printer-Roland-Hardware
  parent_nameRoland
  display_nameRoland Direct-to-Garment Printer
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id79
  parent_id10
  lft154
  rght175
  nameRoland
  template_id23
  slugHardware-Roland
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_titleRoland Large Format Printers and Printers/Cutters
  meta_tag_description
  product_id(null)
  seq75
  modified2023-05-03
  44(array)
  id19
  parent_id11
  nameRoland
  heading
  lft210
  rght219
  primary_brand_id2
  brand_nameRoland DGA
  slugInks-Roland
  parent_nameInks
  display_nameInks Roland
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id11
  parent_id(null)
  lft209
  rght256
  nameInks
  template_id2799
  slugInks
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id0
  seq101
  modified2023-09-20
  45(array)
  id238
  parent_id19
  nameGarment
  heading
  lft211
  rght212
  primary_brand_id2
  brand_nameRoland DGA
  slugGarment-Roland-Inks
  parent_nameRoland
  display_nameRoland Garment
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id19
  parent_id11
  lft210
  rght219
  nameRoland
  template_id2799
  slugInks-Roland
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id0
  seq102
  modified2023-09-20
  46(array)
  id139
  parent_id19
  nameEco-UV
  heading(null)
  lft213
  rght214
  primary_brand_id2
  brand_nameRoland DGA
  slugInks-Roland-Eco-UV
  parent_nameRoland
  display_nameRoland Eco-UV
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id19
  parent_id11
  lft210
  rght219
  nameRoland
  template_id2799
  slugInks-Roland
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id0
  seq102
  modified2023-09-20
  47(array)
  id140
  parent_id19
  nameEco-Sol MAX
  heading(null)
  lft215
  rght216
  primary_brand_id2
  brand_nameRoland DGA
  slugInks-Roland-Eco-Sol-MAX
  parent_nameRoland
  display_nameRoland Eco-Sol MAX
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id19
  parent_id11
  lft210
  rght219
  nameRoland
  template_id2799
  slugInks-Roland
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id0
  seq102
  modified2023-09-20
  48(array)
  id165
  parent_id19
  nameTrueVIS
  heading
  lft217
  rght218
  primary_brand_id2
  brand_nameRoland DGA
  slugTrueVIS-Roland-Inks
  parent_nameRoland
  display_nameRoland TrueVIS
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id19
  parent_id11
  lft210
  rght219
  nameRoland
  template_id2799
  slugInks-Roland
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id0
  seq102
  modified2023-09-20
  49(array)
  id40
  parent_id12
  namePSA
  heading(null)
  lft258
  rght269
  primary_brand_id2
  brand_nameRoland DGA
  slugLamination-PSA
  parent_nameLamination
  display_nameLamination PSA
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id12
  parent_id(null)
  lft257
  rght274
  nameLamination
  template_id22
  slugLamination
  slug_lockY
  publish_flagY
  headingLaminating Supplies
  meta_tag_titleLamination Supplies | Schiller's Digital Printer Group
  meta_tag_descriptionPressure Sensitive PSA, Cast, Foor, Calendered, Polycarbonate , Speciality, and Thermal Lamination. By Seal, Graphic Finishing Partners, Ritrama, Drytac and Arlon.
  product_id(null)
  seq124
  modified2023-05-03
  50(array)
  id75
  parent_id40
  nameFloor
  heading
  lft259
  rght260
  primary_brand_id2
  brand_nameRoland DGA
  slugLamination-PSA-Foor
  parent_namePSA
  display_namePSA Floor
  allN
  masterN
  sub_masterN
  ParentCategory(array)
  id40
  parent_id12
  lft258
  rght269
  namePSA
  template_id22
  slugLamination-PSA
  slug_lockN
  publish_flagY
  heading(null)
  meta_tag_title(null)
  meta_tag_description(null)
  product_id(null)
  seq125
  modified2023-05-03
  51(array)
  id160
  parent_id159
  namePrint/Cut Films
  heading
  lft308
  rght309
  primary_brand_id2
  brand_nameRoland DGA
  slugPrint-Cut-Films-Heat-Transfer-Films
  parent_nameHeat Transfer Films
  display_nameHeat Transfer Films Print/Cut Films
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id159
  parent_id(null)
  lft307
  rght314
  nameHeat Transfer Films
  template_id22
  slugHeat-Transfer-Films
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq149
  modified2023-05-03
  52(array)
  id162
  parent_id159
  nameTransfer Mask
  heading
  lft312
  rght313
  primary_brand_id2
  brand_nameRoland DGA
  slugTransfer-Mask-Heat-Transfer-Films
  parent_nameHeat Transfer Films
  display_nameHeat Transfer Films Transfer Mask
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id159
  parent_id(null)
  lft307
  rght314
  nameHeat Transfer Films
  template_id22
  slugHeat-Transfer-Films
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq149
  modified2023-05-03
  53(array)
  id181
  parent_id180
  namePrint
  heading
  lft330
  rght331
  primary_brand_id2
  brand_nameRoland DGA
  slugPrint-Best-Sellers
  parent_nameBest Sellers
  display_nameBest Sellers Print
  allN
  masterN
  sub_masterY
  ParentCategory(array)
  id180
  parent_id(null)
  lft329
  rght336
  nameBest Sellers
  template_id22
  slugBest-Sellers
  slug_lockN
  publish_flagY
  heading
  meta_tag_title
  meta_tag_description
  product_id(null)
  seq160
  modified2023-05-03
- headingShop Roland DGA Categories
- brand_urlhttps://www.rolanddga.com/
- alt_textLink to Roland DGA Web Site
- isMobileN
- menu<div id="navigation"> <ul class="top-level"><li class= 'product' ><a href='/products/shop/'>Digital Print Media</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Digital-Print-Media'>Backlit</a><ul class='sub-level'><li><a href='/categories/shop/Backlit-Film-Digital-Print-Media'>Film</a></li><li><a href='/categories/shop/Digital-Print-Media-Backlit-Vinyl'>Vinyl</a></li></ul></li><li><a href='/categories/shop/Banner-Digital-Print-Media'>Banner</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Banner-1-Sided'>1-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-2-Sided'>2-Sided</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Banner-RollUp'>RollUp</a></li><li><a href='/categories/shop/Mesh-Banner-Digital-Print-Media'>Mesh</a></li><li><a href='/categories/shop/Stands-Banner-Digital-Print-Media'>Stands</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-CAD'>CAD</a></li><li><a href='/categories/shop/Canvas-Digital-Print-Media'>Canvas</a></li><li><a href='/categories/shop/Digital-Print-Media-Clear-Film'>Clear Film</a><ul class='sub-level'><li class= 'product' ><a href='/products/shop/STS-DTF-Clear-Film-Print-Media'>STS Direct to Film</a></li></ul></li><li><a href='/categories/shop/Digital-Print-Media-Dye-Sublimation-Paper'>Dye Sublimation Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric'>Fabric</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Fabric-Printable'>Printable</a></li><li><a href='/categories/shop/Digital-Print-Media-Fabric-Dye-Sublimation'>Dye Sublimation</a></li></ul></li><li><a href='/categories/shop/Fine-Art-Digital-Print-Media'>Fine Art</a></li><li><a href='/categories/shop/Floor-Digital-Print-Media'>Floor</a></li><li><a href='/categories/shop/Digital-Print-Media-Magnetics'>Magnetics</a></li><li><a href='/categories/shop/Photobase-Digital-Print-Media'>Photobase</a><ul class='sub-level'><li><a href='/categories/shop/Dry-Lab-Photobase-Digital-Print-Media'>Dry Lab</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Adhesive-Backed'>Adhesive Backed</a></li><li><a href='/categories/shop/Digital-Print-Media-Photobase-Paper'>Paper</a></li></ul></li><li><a href='/categories/shop/Calendered-Vinyl-Digital-Print-Media'>Vinyl Calendered</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Clear'>Clear</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Reflective'>Reflective</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Industrial'>Industrial 7-Year</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Calendered-Promotional'>Promotional 3-Year</a></li><li><a href='/categories/shop/Intermediate-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year</a></li><li><a href='/categories/shop/Promotional-3-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Promotional 3-Year Air Release </a></li><li><a href='/categories/shop/Intermediate-5-Year-Air-Release-Vinyl-Calendered-Digital-Print-Media'>Intermediate 5-Year Air Release</a></li></ul></li><li><a href='/categories/shop/Wall-Digital-Print-Media'>Wall</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Wall-PSA'>PSA</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wet-Strength-Paper'>Wet-Strength Paper</a></li><li><a href='/categories/shop/Digital-Print-Media-Wall-Wallpaper'>Wallpaper</a></li></ul></li><li><a href='/categories/shop/Windows-Digital-Print-Media'>Windows</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Cling'>Cling</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-PSA'>PSA</a></li><li><a href='/categories/shop/Perforated-Windows-Digital-Print-Media'>Perforated</a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Outside-Mount'>60/40 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-50-50-Outside-Mount'>50/50 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-60-40-Inside-Mount'>60/40 Inside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-80-20-Outside-Mount'>80/20 Outside Mount</a></li><li><a href='/categories/shop/Digital-Print-Media-Windows-Perforated-65-35-Outside-Mount'>65/35 Outside Mount</a></li><li><a href='/categories/shop/70-30-Outside-Mount-Perforated-Windows-Digital-Print-Media'>70/30 Outside Mount</a></li><li><a href='/categories/shop/80-20-Inside-Mount-Perforated-Windows-Digital-Print-Media'>80/20 Inside Mount </a></li></ul></li><li><a href='/categories/shop/Printable-Etched-Windows-Digital-Print-Media'>Printable Etched</a></li></ul></li><li><a href='/categories/shop/Cast-Vinyl-Digital-Print-Media'>Vinyl Cast </a><ul class='sub-level'><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-White'>White</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Translucent'>Translucent</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Vehicle-Wrap'> Vehicle Wrap</a></li><li><a href='/categories/shop/Digital-Print-Media-Vinyl-Cast-Air-Release'>Air Release</a></li><li><a href='/categories/shop/Reflective-Vinyl-Cast-Digital-Print-Media'>Reflective </a></li></ul></li><li><a href='/categories/shop/Presentation-Digital-Print-Media'>Presentation</a></li><li><a href='/categories/shop/RollUp-Banner-Digital-Print-Media'>RollUp</a></li><li><a href='/categories/shop/Heat-Transfer-Digital-Print-Media'>Heat Transfer</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Digital-Print-Media'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Digital-Print-Media'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Digital-Print-Media'>Transfer Mask</a></li></ul></li><li><a href='/categories/shop/Proofing-Digital-Print-Media'>Proofing</a></li><li><a href='/categories/shop/Durables-Digital-Print-Media'>Durables</a></li><li><a href='/categories/shop/Styrene-Digital-Print-Media'>Styrene</a></li><li><a href='/categories/shop/POS-Digital-Print-Media'>POS</a></li></li></ul><li><a href='/categories/shop/Clearance'>Clearance</a><ul class='sub-level'></li></ul><li><a href='/categories/shop/Graphic-Sign'>Graphic/Sign</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades'>Vinyl Cutter Blades</a><ul class='sub-level'><li><a href='/categories/shop/Graphic-Sign-Vinyl-Cutter-Blades-Roland'>Roland</a></li></ul></li><li><a href='/categories/shop/Graphic-Sign-Vinyl'>Sign Vinyl</a></li><li><a href='/categories/shop/Application-Tape-Graphic-Sign'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Hardware'>Hardware</a><ul class='sub-level'><li><a href='/categories/shop/Hardware-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Resin-Roland'>Resin</a></li><li><a href='/categories/shop/Hardware-Roland-Print-Only'>Print Only</a></li><li><a href='/categories/shop/Hardware-Roland-Printer-Cutters'>Printer/Cutters</a></li><li><a href='/categories/shop/UV-Benchtop-Flatbed-Roland-Hardware'>UV Benchtop Flatbed</a></li><li><a href='/categories/shop/Hardware-Roland-UV-Printer-Cutters'>UV Printer/Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Vinyl-Cutters'>Vinyl Cutters</a></li><li><a href='/categories/shop/Hardware-Roland-Sublimation'>Sublimation</a></li><li><a href='/categories/shop/Hardware-Roland-Common-Replacement-Parts'>Replacement Parts</a></li><li><a href='/categories/shop/UV-Flatbed-Roland-Hardware'>UV Flatbed</a></li><li class= 'product' ><a href='/products/shop/Roland-DGA-XT-640S-DTG-Multi-Station-Direct-to-Garment-Printer'>Direct-to-Garment Printer</a></li></ul></li><li><a href='/categories/shop/Hardware-GFP-Graphic-Finish-Partners'>GFP (Graphic Finish Partners)</a></li><li><a href='/categories/shop/Vanguard-Digital-UV-Flatbed-Printer-Hardware'>Vanguard Digital UV Flatbed Printer</a></li></li></ul><li class= 'product' ><a href='/products/shop/'>Inks</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Roland'>Roland</a><ul class='sub-level'><li><a href='/categories/shop/Garment-Roland-Inks'>Garment</a></li><li><a href='/categories/shop/Inks-Roland-Eco-UV'>Eco-UV</a></li><li><a href='/categories/shop/Inks-Roland-Eco-Sol-MAX'>Eco-Sol MAX</a></li><li><a href='/categories/shop/TrueVIS-Roland-Inks'>TrueVIS</a></li></ul></li><li><a href='/categories/shop/Inks-SPL-Brand'>SPL Brand</a><ul class='sub-level'><li><a href='/categories/shop/Inks-SPL-Brand-Roland'>Roland</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Epson'>Epson</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-SPL-Brand-Mutoh'>Mutoh</a></li><li><a href='/categories/shop/HP-SPL-Brand-Inks'>HP</a></li><li><a href='/categories/shop/Mimaki-SPL-Brand-Inks'>Mimaki</a></li><li><a href='/categories/shop/Oki-Data-SPL-Brand-Inks'>Oki Data</a></li></ul></li><li><a href='/categories/shop/Inks-Seiko-Okidata'>Seiko/Okidata</a></li><li><a href='/categories/shop/Inks-Canon'>Canon</a></li><li><a href='/categories/shop/Inks-Epson'>Epson</a><ul class='sub-level'><li><a href='/categories/shop/Inks-Epson-Epson-OEM'>Epson OEM</a></li><li><a href='/categories/shop/Inks-Epson-SPL-Brand'>SPL Brand</a></li></ul></li><li><a href='/categories/shop/Inks-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Vanguard-Digital-Inks'>Vanguard Digital</a></li><li><a href='/categories/shop/HP-Inks'>HP</a><ul class='sub-level'></ul></li><li><a href='/categories/shop/STS-Direct-to-Film-Supplies'>STS Direct to Film Supplies</a></li></li></ul><li><a href='/categories/shop/Lamination'>Lamination</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Lamination-PSA-Foor'>Floor</a></li><li><a href='/categories/shop/Lamination-PSA-Cast'>Cast</a></li><li><a href='/categories/shop/Lamination-PSA-Calendered'>Calendered</a></li><li><a href='/categories/shop/Lamination-PSA-Polycarbonate'>Polycarbonate </a></li><li><a href='/categories/shop/Lamination-PSA-Speciality'>Speciality</a></li></ul></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li><li><a href='/categories/shop/Thermal-Lamination-Supplies'>Thermal</a></li></li></ul><li><a href='/categories/shop/Mounting-Supplies'>Mounting</a><ul class='sub-level'><li><a href='/categories/shop/PSA-Mounting'>PSA</a><ul class='sub-level'><li><a href='/categories/shop/Mounting-PSA-Clear'>Clear</a></li><li><a href='/categories/shop/Mounting-PSA-White'>White</a></li><li><a href='/categories/shop/Mounting-PSA-Window'>Window</a></li></ul></li><li><a href='/categories/shop/Heat-Activated-Backing-Films-Mounting'>Heat-Activated Backing Films</a></li><li class= 'product' ><a href='/products/shop/Kraft-Paper'>Kraft Paper</a></li></li></ul><li><a href='/categories/shop/Shop-Tools-Supplies'>Shop Tools & Supplies</a><ul class='sub-level'><li><a href='/categories/shop/Shop-Tools-Supplies-Safety-Rulers'>Safety Rulers</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Media-Racks'>Media Racks</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommet-Press'>Grommet Press</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-UV-Adhesion-Promoters'>UV Adhesion Promoters</a></li><li><a href='/categories/shop/Shop-Tools-Supplies-Grommets'>Grommets</a></li><li><a href='/categories/shop/Squeegees-Shop-Tools-Supplies'>Squeegees</a></li><li><a href='/categories/shop/Cutting-Tools-and-Supplies-Shop-Tools-Supplies'>Cutting Tools and Supplies</a></li><li><a href='/categories/shop/Weeding-Tools-Shop-Tools-Supplies'>Weeding Tools</a></li></li></ul><li><a href='/categories/shop/Heat-Transfer-Films'>Heat Transfer Films</a><ul class='sub-level'><li><a href='/categories/shop/Print-Cut-Films-Heat-Transfer-Films'>Print/Cut Films</a></li><li><a href='/categories/shop/Cut-Films-Heat-Transfer-Films'>Cut Films</a></li><li><a href='/categories/shop/Transfer-Mask-Heat-Transfer-Films'>Transfer Mask </a></li></li></ul><li><a href='/categories/shop/Sign-Vinyl'>Sign Vinyl</a><ul class='sub-level'><li><a href='/categories/shop/Premium-Sign-Vinyl'>Premium </a></li><li><a href='/categories/shop/Intermediate-Sign-Vinyl'>Intermediate </a></li><li><a href='/categories/shop/Decorative-Sign-Vinyl'>Decorative </a></li><li><a href='/categories/shop/Specialty-Sign-Vinyl'>Specialty</a></li><li><a href='/categories/shop/Reflective-Sign-Vinyl'>Reflective </a></li><li><a href='/categories/shop/Application-Tape-Sign-Vinyl'>Application Tape</a></li></li></ul><li><a href='/categories/shop/Best-Sellers'>Best Sellers</a><ul class='sub-level'><li><a href='/categories/shop/Print-Best-Sellers'>Print</a></li><li><a href='/categories/shop/Protection-Best-Sellers'>Protection</a></li><li><a href='/categories/shop/Mounting-Best-Sellers'>Mounting</a></li></li></ul><li><a href='/categories/shop/New-Products'>New Products</a><ul class='sub-level'></li></ul></ul></div>
- $request->data(empty)
- $this->validationErrors(array)
  UserSetting(empty)
  User(empty)
  UserGroup(empty)
  UserActivity(empty)
  Brand(empty)
  Category(empty)
  BrandsProduct(empty)
  Product(empty)
  ParentCategory(empty)
  CategoriesProduct(empty)
  InkType(empty)
- Loaded Helpers(array)
  0Form
  1Html
  2Session
  3Js
  4UserAuth
  5Image
  6Number
  7SimpleGraph
  8DebugTimer
  9Toolbar
  10Flash
  11HtmlToolbar
====

Time	Message
2025-12-05 20:59:13	Data AppController:
2025-12-05 20:59:13	layout_default default.ctp:
2025-12-05 20:59:13	Data default_page:

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Config/
AUTHORIZENET_LOG_FILE	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/logs/auth_net.log
SITE_URL	https://dpgtest.schillers.com/
SITE_NAME	Schillers, DPG
SITE_REGISTRATION	1
ALLOW_DELETE_ACCOUNT	0
SEND_REGISTRATION_MAIL	1
SEND_PASSWORD_CHANGE_MAIL	1
EMAIL_VERIFICATION	0
EMAIL_FROM_ADDRESS	dpg@schillers.com
EMAIL_FROM_NAME	Schillers, DPG
ALLOW_CHANGE_USERNAME	1
BANNED_USERNAMES	Administrator, SuperAdmin
USE_RECAPTCHA	0
PRIVATE_KEY_FROM_RECAPTCHA
PUBLIC_KEY_FROM_RECAPTCHA
LOGIN_REDIRECT_URL	/
LOGOUT_REDIRECT_URL	/
PERMISSIONS	1
ADMIN_PERMISSIONS	0
DEFAULT_GROUP_ID	2
ADMIN_GROUP_ID	1
GUEST_GROUP_ID	3
USE_FB_LOGIN	0
FB_APP_ID
FB_SECRET
FB_SCOPE	user_status, publish_stream, email
USE_TWT_LOGIN	0
TWT_APP_ID
TWT_SECRET
USE_GMAIL_LOGIN	0
GMAIL_API_KEY
GMAIL_CLIENT_ID
GMAIL_CLIENT_SECRET
USE_YAHOO_LOGIN	0
USE_LDN_LOGIN	0
LDN_API_KEY
LDN_SECRET_KEY
USE_FS_LOGIN	0
FS_CLIENT_ID
FS_CLIENT_SECRET
VIEW_ONLINE_USER_TIME	30
USE_HTTPS	1
HTTPS_URLS
IMG_DIR	umphotos_not_used
QRDN	12345694
LOGIN_COOKIE_NAME	UMPremiumCookie
DEFAULT_IMAGE_PATH	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Plugin/Usermgmt/webroot/img/default.jpg
DEFAULT_IMAGE_URL	https://dpgtest.schillers.com/usermgmt/img/default.jpg
ADMIN_EMAIL_ADDRESS	s.moeckel@schillers.com
USE_RECAPTCHA_ON_LOGIN	0
BAD_LOGIN_ALLOW_COUNT	5
USE_RECAPTCHA_ON_REGISTRATION	0
USE_RECAPTCHA_ON_FORGOT_PASSWORD	0
USE_RECAPTCHA_ON_EMAIL_VERIFICATION	0
USE_REMEMBER_ME	1
ALLOW_USER_MULTIPLE_LOGIN	1
ALLOW_ADMIN_MULTIPLE_LOGIN	1
LOGIN_IDLE_TIME	120

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Lib/
CACHE	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/cache/
CAKE	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib
CORE_PATH	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/
CAKE_VERSION	2.10.7
CSS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://dpgtest.schillers.com
IMAGES	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/logs/
ROOT	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com
TESTS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/Test/
TMP	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/tmp/
VENDORS	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.5.38
Path	/sbin:/usr/sbin:/bin:/usr/bin
Pp Custom Php Ini	/var/www/vhosts/system/dpgtest.schillers.com/etc/php.ini
Pp Custom Php Cgi Index	plesk-php55-fastcgi
Http Connection	close
Script Name	/app/webroot/index.php
Request Uri	/brands/shop_categories_by_brand/Roland%20DGA
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/brands/shop_categories_by_brand/Roland DGA
Remote Port	51062
Script Filename	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/app/webroot/index.php
Server Admin	root@localhost
Document Root	/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com
Remote Addr	216.73.216.151
Server Port	443
Server Addr	74.208.101.187
Server Name	dpgtest.schillers.com
Server Software	Apache
Server Signature	<address>Apache Server at dpgtest.schillers.com Port 443</address>
Http Host	dpgtest.schillers.com
Http Accept Encoding	gzip, br, zstd, deflate
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Ssl Tls Sni	dpgtest.schillers.com
Https	on
Unique Id	aTOcAUrQSlAAAHT4XQYAAADf
Redirect Status	200
Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Https	on
Redirect Unique Id	aTOcAUrQSlAAAHT4XQYAAADf
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	dpgtest.schillers.com
Redirect Redirect Https	on
Redirect Redirect Unique Id	aTOcAUrQSlAAAHT4XQYAAADf
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1764989953.1682
Request Time	1764989953

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib
- 2/opt/plesk/php/5.5/share/pear
- 3-> /var/www/vhosts/u18197277.onlinehome-server.com/httpdocs/dpgtest.schillers.com/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/FlashComponent.php
  2CORE/Controller/Component/RequestHandlerComponent.php
  3CORE/Controller/Component/PaginatorComponent.php
  4CORE/Controller/Component/CookieComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/dpgComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/BrandsController.php
  1APP/Controller/AppController.php
  2APP/Controller/AccountsController.php
  3APP/Controller/AssetsController.php
  4APP/Controller/CartsController.php
  5APP/Controller/CatalogsController.php
  6APP/Controller/CategoriesController.php
  7APP/Controller/CategoriesProductsController.php
  8APP/Controller/ColorSelectorItemsController.php
  9APP/Controller/ColorSelectorsController.php
  10APP/Controller/CompaniesController.php
  11APP/Controller/ConfigurationsController.php
  12APP/Controller/Cp1SpecialPricesController.php
  13APP/Controller/DocsController.php
  14APP/Controller/DpgAssetsController.php
  15APP/Controller/Ec1SeoRedirectLogsController.php
  16APP/Controller/Ec1SeoRedirectsController.php
  17APP/Controller/ExportsController.php
  18APP/Controller/FreightCodesController.php
  19APP/Controller/GroupsController.php
  20APP/Controller/ImportsController.php
  21APP/Controller/InkProductsController.php
  22APP/Controller/InkTypesController.php
  23APP/Controller/ItemHistoriesController.php
  24APP/Controller/ItemsController.php
  25APP/Controller/KitsController.php
  26APP/Controller/M1AssetTypesController.php
  27APP/Controller/M1AssetsController.php
  28APP/Controller/M1CompaniesController.php
  29APP/Controller/M1CompanyAssetsController.php
  30APP/Controller/MarketingsController.php
  31APP/Controller/OrderLinesController.php
  32APP/Controller/OrdersController.php
  33APP/Controller/PagesController.php
  34APP/Controller/PaymentTermsController.php
  35APP/Controller/PhotosController.php
  36APP/Controller/ProductSideBarsController.php
  37APP/Controller/ProductsController.php
  38APP/Controller/RegistrationsController.php
  39APP/Controller/SeeAlsosController.php
  40APP/Controller/SeoRedirectsController.php
  41APP/Controller/ShippingHeadersController.php
  42APP/Controller/ShippingRatesController.php
  43APP/Controller/SitemapsController.php
  44APP/Controller/SlidersController.php
  45APP/Controller/SpecificationDetailsController.php
  46APP/Controller/SpecificationsController.php
  47APP/Controller/SubGroupsController.php
  48APP/Controller/TemplatesController.php
  49APP/Controller/TestMethodsController.php
  50APP/Controller/UnitsController.php
  51APP/Controller/UtilitiesController.php
  52APP/Controller/VendorsController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Brand.php
  2APP/Model/Category.php
  3APP/Model/BrandsProduct.php
  4APP/Model/Product.php
  5APP/Model/InkType.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/autoload.php
  2APP/Vendor/composer/autoload_real.php
  3APP/Vendor/composer/ClassLoader.php
  4APP/Vendor/composer/autoload_namespaces.php
  5APP/Vendor/composer/autoload_psr4.php
  6APP/Vendor/composer/autoload_classmap.php
  7APP/Vendor/composer/autoload_files.php
  8APP/Vendor/symfony/polyfill-mbstring/bootstrap.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Controller(array)
  0DebugKit/Controller/DebugKitAppController.php
  1DebugKit/Controller/ToolbarAccessController.php
  Usermgmt(array)
  Config(array)
  0Usermgmt/Config/bootstrap.php
  1Usermgmt/Config/routes.php
  Plugin(array)
  0Usermgmt/Lib/routes/SlugRoute.php
  Component(array)
  0Usermgmt/Controller/Component/UserAuthComponent.php
  1Usermgmt/Controller/Component/ControllerListComponent.php
  2Usermgmt/Controller/Component/SslComponent.php
  Model(array)
  0Usermgmt/Model/UserSetting.php
  1Usermgmt/Model/UserMgmtAppModel.php
  2Usermgmt/Model/User.php
  3Usermgmt/Model/UserGroup.php
  4Usermgmt/Model/UserActivity.php
  Controller(array)
  0Usermgmt/Controller/UserMgmtAppController.php
  1Usermgmt/Controller/AutocompleteController.php
  2Usermgmt/Controller/ContentsController.php
  3Usermgmt/Controller/UserBillTosController.php
  4Usermgmt/Controller/UserCompaniesController.php
  5Usermgmt/Controller/UserContactsController.php
  6Usermgmt/Controller/UserEmailSignaturesController.php
  7Usermgmt/Controller/UserEmailTemplatesController.php
  8Usermgmt/Controller/UserEmailsController.php
  9Usermgmt/Controller/UserGroupPermissionsController.php
  10Usermgmt/Controller/UserGroupsController.php
  11Usermgmt/Controller/UserSettingsController.php
  12Usermgmt/Controller/UserShipTosController.php
  13Usermgmt/Controller/UsersController.php
====

Shop Roland DGA Categories

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 424 ms Total Queries: 362 queries

Query Explain:

Memory

Timers

Logs

debug

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 424 ms
Total Queries: 362 queries